﻿CREATE TABLE [dbo].[Attributes] (
    [ID]          INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Name]        VARCHAR (400) NOT NULL,
    [IsReference] BIT           NOT NULL,
    [SystemType]  VARCHAR (255) NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [ix_Name]
    ON [dbo].[Attributes]([Name] ASC)
    INCLUDE([ID], [IsReference]);

